NYC 311 Data

Intrest and Exploration

Yang Kang Chua and Shen Tong

Overview

  • Research Questions
  • Data
  • Analysis and Visualisation
  • Conclusion

Research Question

What suggestions we can give for individuals (friends or clients) seeking to purchase a neighbor-friendly house in NYC?

Data Review

Lets take a look at our current cleaned data set.

Index(['Unique Key', 'Created Date', 'Closed Date', 'Duration (hours)',
       'Day type', 'Agency', 'Agency Name', 'Complaint Type', 'Descriptor',
       'Location Type', 'Incident Zip', 'Incident Address', 'Street Name',
       'Cross Street 1', 'Cross Street 2', 'Intersection Street 1',
       'Intersection Street 2', 'Address Type', 'City', 'Landmark',
       'Facility Type', 'Status', 'Due Date', 'Resolution Description',
       'Resolution Action Updated Date', 'Community Board', 'BBL', 'Borough',
       'X Coordinate (State Plane)', 'Y Coordinate (State Plane)',
       'Open Data Channel Type', 'Park Facility Name', 'Park Borough',
       'Vehicle Type', 'Taxi Company Borough', 'Taxi Pick Up Location',
       'Bridge Highway Name', 'Bridge Highway Direction', 'Road Ramp',
       'Bridge Highway Segment', 'Latitude', 'Longitude', 'Location'],
      dtype='object')

Merging

We begin by merging the data with zipcode database.

Unique Key Created Date Closed Date Duration (hours) Day type Agency Agency Name Complaint Type Descriptor Location Type Incident Zip Incident Address Street Name Cross Street 1 Cross Street 2 Intersection Street 1 Intersection Street 2 Address Type City Landmark Facility Type Status Due Date Resolution Description Resolution Action Updated Date Community Board BBL Borough X Coordinate (State Plane) Y Coordinate (State Plane) Open Data Channel Type Park Facility Name Park Borough Vehicle Type Taxi Company Borough Taxi Pick Up Location Bridge Highway Name Bridge Highway Direction Road Ramp Bridge Highway Segment Latitude Longitude Location zipcode_type major_city post_office_city common_city_list county state timezone radius_in_miles area_code_list population population_density land_area_in_sqmi water_area_in_sqmi housing_units occupied_housing_units median_home_value median_household_income bounds_west bounds_east bounds_north bounds_south
0 56524984 2023-01-15 00:00:18 2023-01-15 02:37:30 2.620000 Weekend NYPD New York City Police Department Noise - Residential Banging/Pounding Residential Building/House 10467.0 2504 BRONX PARK EAST BRONX PARK EAST MACE AVENUE ALLERTON AVENUE MACE AVENUE ALLERTON AVENUE ADDRESS BRONX BRONX PARK EAST NaN Closed NaN The Police Department responded to the complai... 01/15/2023 02:37:36 AM 11 BRONX 2.044270e+09 BRONX 1020095.0 253941.0 ONLINE Unspecified BRONX NaN NaN NaN NaN NaN NaN NaN 40.863611 -73.870409 (40.8636112787934, -73.87040864262848) STANDARD Bronx Bronx, NY b'x\x9c\x8bVr*\xca\xcf\xabP\x8a\x05\x00\x0e\xb... Bronx County NY America/New_York 2.000000 b'x\x9cS261\xd717\xb4P\x02\x00\x08f\x01\xaf' 97060.0 41649.0 2.33 0.0 37432.0 35524.0 369500.0 36048.0 -73.895710 -73.855691 40.908016 40.857266
1 56526790 2023-01-15 00:00:21 2023-01-15 01:54:24 1.900833 Weekend NYPD New York City Police Department Noise - Street/Sidewalk Loud Music/Party Street/Sidewalk 11418.0 113-22 BESSEMER STREET BESSEMER STREET 84 AVENUE 114 STREET 84 AVENUE 114 STREET ADDRESS RICHMOND HILL BESSEMER STREET NaN Closed NaN The Police Department responded to the complai... 01/15/2023 01:54:28 AM 09 QUEENS 4.092110e+09 QUEENS 1029284.0 195357.0 MOBILE Unspecified QUEENS NaN NaN NaN NaN NaN NaN NaN 40.702772 -73.837580 (40.70277200816068, -73.83758019372564) STANDARD Richmond Hill Richmond Hill, NY b'x\x9c\x8bV\n\xcaL\xce\xc8\xcd\xcfKQ\xf0\xc8\... Queens County NY America/New_York 1.000000 b'x\x9cS261\xd7\xb14\x04b#K\x1dsC\x0b%\x00\x1d... 36256.0 22201.0 1.63 0.0 11854.0 11031.0 427000.0 60691.0 -73.854747 -73.813659 40.711641 40.689442
2 56525034 2023-01-15 00:00:50 2023-01-15 01:09:56 1.151667 Weekend NYPD New York City Police Department Illegal Parking Posted Parking Sign Violation Street/Sidewalk 11217.0 50 NEVINS STREET NEVINS STREET SCHERMERHORN STREET STATE STREET SCHERMERHORN STREET STATE STREET ADDRESS BROOKLYN NEVINS STREET NaN Closed NaN The Police Department responded to the complai... 01/15/2023 01:10:00 AM 02 BROOKLYN 3.001728e+09 BROOKLYN 989264.0 189641.0 MOBILE Unspecified BROOKLYN NaN NaN NaN NaN NaN NaN NaN 40.687196 -73.981921 (40.68719608843765, -73.98192072171082) STANDARD Brooklyn Brooklyn, NY b'x\x9c\x8bVr*\xca\xcf\xcf\xce\xa9\xccS\x8a\x0... Kings County NY America/New_York 0.909091 b'x\x9cS231\xd317\xb4P\x02\x00\x08x\x01\xb1' 35881.0 47796.0 0.75 0.0 17581.0 16269.0 857000.0 81862.0 -73.990867 -73.970640 40.689901 40.672639
3 56526234 2023-01-15 00:01:02 2023-01-15 05:47:41 5.777500 Weekend NYPD New York City Police Department Noise - Residential Loud Music/Party Residential Building/House 10472.0 1988 NEWBOLD AVENUE NEWBOLD AVENUE DEAD END EAST 177 STREET DEAD END EAST 177 STREET ADDRESS BRONX NEWBOLD AVENUE NaN Closed NaN The Police Department responded to the complai... 01/15/2023 05:47:47 AM 09 BRONX 2.037940e+09 BRONX 1023295.0 242559.0 ONLINE Unspecified BRONX NaN NaN NaN NaN NaN NaN NaN 40.832358 -73.858906 (40.83235751279932, -73.85890589915455) STANDARD Bronx Bronx, NY b'x\x9c\x8bVr*\xca\xcf\xabP\x8a\x05\x00\x0e\xb... Bronx County NY America/New_York 1.000000 b'x\x9cS27\xb4P\x02\x00\x02\xb0\x00\xe5' 66358.0 63167.0 1.05 0.0 23386.0 22002.0 429600.0 30288.0 -73.884568 -73.845633 40.836137 40.823160
4 56530817 2023-01-15 00:01:07 2023-01-15 01:01:26 1.005278 Weekend NYPD New York City Police Department Noise - Residential Banging/Pounding Residential Building/House 10028.0 522 EAST 83 STREET EAST 83 STREET YORK AVENUE EAST END AVENUE YORK AVENUE EAST END AVENUE ADDRESS NEW YORK EAST 83 STREET NaN Closed NaN The Police Department responded to the complai... 01/15/2023 01:01:33 AM 08 MANHATTAN 1.015790e+09 MANHATTAN 998699.0 221149.0 ONLINE Unspecified MANHATTAN NaN NaN NaN NaN NaN NaN NaN 40.773667 -73.947833 (40.773667438961155, -73.94783272698673) STANDARD New York New York, NY b'x\x9c\x8bV\xf2K-W\x88\xcc/\xcaV\x8a\x05\x00\... New York County NY America/New_York 0.852273 b'x\x9cS224\xd2161\xd7131\xd3\xb144W\x02\x00\x... 45141.0 143683.0 0.31 0.0 28139.0 25158.0 1000001.0 104638.0 -73.963230 -73.944337 40.782213 40.770062

Visualisation

Complaint Locations

Show plot (and the code that generated it)

Complaint Density

Make this Notebook Trusted to load map: File -> Trust Notebook

Complaint type per zip code

Make this Notebook Trusted to load map: File -> Trust Notebook
Make this Notebook Trusted to load map: File -> Trust Notebook

Factor that impact the complaints

  • Live near NYPD?
  • Live in a area with higher house price?

Live Near NYPD?

Make this Notebook Trusted to load map: File -> Trust Notebook

Live in a area with higher house price?

Make this Notebook Trusted to load map: File -> Trust Notebook

<ggplot: (95886669734)>

Conclusion

  • Analyzing complaint data can help us find a good place to live.
  • Plotting complaints on a map shows areas with higher complaint volumes and patterns unique to certain neighborhoods.
  • We found some neighborhoods that might be friendlier for different needs, but there’s no clear evidence that living near NYPD or paying higher house prices correlates with friendlier neighbors.
  • When choosing a neighborhood, it’s important to consider personal needs and preferences.